Run Cypher template assets_overdue_for_task@3read-only
parameterized · cost & row guard ✓
bound query
MATCH (s:Site {id: $site_id})-[:CONTAINS]->(a:Asset)
MATCH (a)<-[:TARGETS]-(wo:WorkOrder)-[:EXECUTES]->(t:MaintenanceTask {code: $task_code})
WHERE wo.due_date < date() AND wo.status <> 'CLOSED'RETURN a.id, a.name, wo.due_date, wo.status ORDER BY wo.due_date